package com.ninthgroup.mapper;

import com.ninthgroup.entity.Doctor;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface DoctorMapper {
    int deleteByPrimaryKey(Integer dId);

    int insert(Doctor record);

    int insertSelective(Doctor record);

    Doctor selectByPrimaryKey(Integer dId);

    int updateByPrimaryKeySelective(Doctor record);

    int updateByPrimaryKey(Doctor record);

    /**
     * @create by: 1452863884@qq.com rcg
     * @description:分页和查询
     * @create time: 2022/10/19 21:49
     * @param dName
     * @param dTelphone
     * @return java.util.List<com.ninthgroup.entity.Doctor>
     */
    List<Doctor> selectAll(@Param("dName") String dName, @Param("dTelphone") String dTelphone);



    Doctor findByDoctornameAndPassword(@Param("dName")String dName, @Param("dPassword")String dPassword);


    List<Doctor> selectManyTable(Integer dId);


    List<Doctor> selectAllToScheduing();



    //统计
    int selectSexMan();

    int selectSexWomen();

    int selectByAge0_20();

    int selectByAge20_40();

    int selectByAge40_60();

    int selectByAge60();


}